UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4vtPxoJREDBFP4VnRhr49faHwBqqaoN1iVF3jLV62H8='
WHERE
key_id = 'bd9d2a15b12f53fd7fb41433d8094ca3926779554ab0535aa7cb7788dfd14c42'
AND (
token = '4vtPxoJREDBFP4VnRhr49faHwBqqaoN1iVF3jLV62H8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)