UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtH+oYJU8bXhh89e5qCVCCqp3s7lZk8fpttFI9OHs+k='
WHERE
key_id = '02dea99aead457ae3ad7e224123822fc40603f442163aaf2350a1c8759f05402'
AND (
token = 'BtH+oYJU8bXhh89e5qCVCCqp3s7lZk8fpttFI9OHs+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)