UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tF8pLzaKF7tefJxIsy73jY0LrYPXCYvYpr5rrj5Arfc='
WHERE
key_id = 'e5e061cfe1d3f10577fe0838bd1da85151a35756ecb01b3460cbdd68fe78b8ab'
AND (
token = 'tF8pLzaKF7tefJxIsy73jY0LrYPXCYvYpr5rrj5Arfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)