UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/h8SgK5qZ8fpf4nqncGH/Qlz4vp9GjIELSjlqD/mdE='
WHERE
key_id = 'e154a729dd2ae5d0fcd343be5808ac3e031d4095f630e903100aca375bcd70ee'
AND (
token = 'P/h8SgK5qZ8fpf4nqncGH/Qlz4vp9GjIELSjlqD/mdE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)