UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPdmncDJKAh+2Nv1lnAZqQ5bdedxXFpH7lMIVTO1tlc='
WHERE
key_id = 'a5c23d18f755727cb6340f22c735516882d2f08c94369489e24faf2bcb016b0c'
AND (
token = 'BPdmncDJKAh+2Nv1lnAZqQ5bdedxXFpH7lMIVTO1tlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)