UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ktlp+HDXqYKlJyafL/TC3fBPntzImPhegL1Ijjy7P8='
WHERE
key_id = '3172d2245bfcf787d09bd89d5b6456cb5449a15f453e7274e42b2fb9bd847432'
AND (
token = '6ktlp+HDXqYKlJyafL/TC3fBPntzImPhegL1Ijjy7P8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)