UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnJeYHAmyWLEVLgZ0CbwYOjVLumHtPIUJhvnajkCjv4='
WHERE
key_id = '01ddaef39cde33fcb803f9c2625945fb8b721597e83f952dde30337e3e2b1866'
AND (
token = 'CnJeYHAmyWLEVLgZ0CbwYOjVLumHtPIUJhvnajkCjv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)