UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6O9p/IkzIPOmLNxSEkF6V6wB5adSELhwdekpMyz95Kg='
WHERE
key_id = '586598464ee47458cee393da84d23f2548e7ee35777ea2123b3c3c6df40eac20'
AND (
token = '6O9p/IkzIPOmLNxSEkF6V6wB5adSELhwdekpMyz95Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)