UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O7BY3q+pesEsQ22pzDkSuxcT0Wu7kxLIPtMPXTzHKgU='
WHERE
key_id = 'e9f593b9b9a6711c17a8951365b36997d79bb08debdb1f0643a74c1716ffa3b0'
AND (
token = 'O7BY3q+pesEsQ22pzDkSuxcT0Wu7kxLIPtMPXTzHKgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)