UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yfha1XcUpKE1Xfmn6W7clfmrhLFlfkeP90AraQi3T9Y='
WHERE
key_id = 'ec16a14b47a3954fd1e45aa42a3553a2675840665c4ac24bfcacafd4dbe1e268'
AND (
token = 'yfha1XcUpKE1Xfmn6W7clfmrhLFlfkeP90AraQi3T9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)