UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aHC0KK6W4b2o/WG8ABxnINOoyPD67EEyN70yU6Ev1gA='
WHERE
key_id = 'b5f287b1348c6707582aadaa9301021b5a4556c795164cc211d6562007f7506e'
AND (
token = 'aHC0KK6W4b2o/WG8ABxnINOoyPD67EEyN70yU6Ev1gA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)