UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FPI23PRnUoqb0cuCodmI8KiBmSbmpwsCfZHDrno2I0='
WHERE
key_id = '550820f2a1bca45e9196fe8fc0c98ac5d805033322ca7c02d1d895701a792b11'
AND (
token = '6FPI23PRnUoqb0cuCodmI8KiBmSbmpwsCfZHDrno2I0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)