UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4t4ygFwbUUTUwuIow4OUw4NMSoesRY7BPnAg+1ns3fw='
WHERE
key_id = 'f489c309c565916b78ac254acc0fa4f75f4dd6dc98ffb8a264bb22679e4af5b9'
AND (
token = '4t4ygFwbUUTUwuIow4OUw4NMSoesRY7BPnAg+1ns3fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)