UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6jLszxMnKempi0kvsAmYorBYi1QGNZ0GrG9gcOS+Z0='
WHERE
key_id = '8865dc60c8ee063c7acbeb26974910a46e3d5134793edbe9f8506d7d2d010531'
AND (
token = 'N6jLszxMnKempi0kvsAmYorBYi1QGNZ0GrG9gcOS+Z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)