UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BbWxYxGZu2Rg77TbSj9hjDM9ww1Y0rbZNHi19G50Nig='
WHERE
key_id = '540fbc96ec23de9c32658376317d4058425c69920fab76a36ae4983d16223eee'
AND (
token = 'BbWxYxGZu2Rg77TbSj9hjDM9ww1Y0rbZNHi19G50Nig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)