UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rSJPxz1vNTvTEez63RfwZJIgRdcBXzdPazaV/otNcOM='
WHERE
key_id = 'c7d30de1949b7181363ff9697e76a7b97fdcdf9bcee2eeb2abc224c57721627a'
AND (
token = 'rSJPxz1vNTvTEez63RfwZJIgRdcBXzdPazaV/otNcOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)