UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mE/TjarTzpPDJd7cVSdp6fAW48kZkrW85mnVJX1PxiM='
WHERE
key_id = 'a1e7813bfbc18ecad35d2ce847c3becadee4c88c168c4863376ab934a011ccae'
AND (
token = 'mE/TjarTzpPDJd7cVSdp6fAW48kZkrW85mnVJX1PxiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)