UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V7TezN5gNhd31qdPgAClBhVGf3u9yr6WA0YpJ8Okpv8='
WHERE
key_id = '4001907a9a4b38c191ce9efaa22adf5e57cb5c94c14657440458d517685d2678'
AND (
token = 'V7TezN5gNhd31qdPgAClBhVGf3u9yr6WA0YpJ8Okpv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)