UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06cR+MZ3JAmD+BH2aUUQdq5splK5ytwKRcE2fG++ufc='
WHERE
key_id = 'c424fb78b94b338e7516663905e3a5140e752e9b8b182f6e1d49e63b3710b29b'
AND (
token = '06cR+MZ3JAmD+BH2aUUQdq5splK5ytwKRcE2fG++ufc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)