UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BdBh4o2PnO8KF/EdCqJEuQ054hZGFgnjceniXRyYH/w='
WHERE
key_id = '0270d20ae28dd04c5fb1d5d3beeae0f8ce4d6e6c14f09ba424d5ac5017b93d99'
AND (
token = 'BdBh4o2PnO8KF/EdCqJEuQ054hZGFgnjceniXRyYH/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)