UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ij3RJkWATdTTsxLoe9iVK+ot35Q+LSf/jC0Lb49zk2c='
WHERE
key_id = '2a7d8c8fa717ff0c31bcf9c764e0ba8b434fe1a2d014914e334a8a32735de5fc'
AND (
token = 'ij3RJkWATdTTsxLoe9iVK+ot35Q+LSf/jC0Lb49zk2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)