UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qm4j2nhusP6En7mFwgsKKHatanO/2zmpY4V4o8kWG8M='
WHERE
key_id = '7a694a8cb9dfe1a0ff01a0482110a4735e96da117aeb136de8baf6a93f8a9054'
AND (
token = 'qm4j2nhusP6En7mFwgsKKHatanO/2zmpY4V4o8kWG8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)