UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PW10Z3/O1hoEKyPQZsAVb2wNrsNMiqA2tUrkpmkwEaM='
WHERE
key_id = 'a6405d83e4904991af8811d57bb6381321171238a4070dd49806735a51e8d647'
AND (
token = 'PW10Z3/O1hoEKyPQZsAVb2wNrsNMiqA2tUrkpmkwEaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)