UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '11ofM45ml1I2HcTM5/l4kyvjZJjE93mT1IgtT9aBrUY='
WHERE
key_id = 'a9ac1f60af3d909270914d3f13c8576d39d3f21cf9e29169bcaa13b92b78a5d5'
AND (
token = '11ofM45ml1I2HcTM5/l4kyvjZJjE93mT1IgtT9aBrUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)