UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oxAeKDafJ2HgfGA5UQ/PBHJ8rwHaArU4NDRqfR1uObg='
WHERE
key_id = '8a51ad60ce5304e3dd3df07b64f08a770084c0eb7a42b08ca4a868d6445d68f0'
AND (
token = 'oxAeKDafJ2HgfGA5UQ/PBHJ8rwHaArU4NDRqfR1uObg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)