UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lJMhjHkNFppD2hXOcEVz+0FHFskeBAgwF47dpKtdpfM='
WHERE
key_id = 'f2e81efa58b2ea15283fd503df90651d5761cf6dde108084579cffd3a5c807ae'
AND (
token = 'lJMhjHkNFppD2hXOcEVz+0FHFskeBAgwF47dpKtdpfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)