UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nG8p2zjAzhkcO943BJ/XjALjQZouuV2t9BrTRgamHuM='
WHERE
key_id = 'a360a5502064bcd9e92989762816b7a05c41cebad7b720d8551404eaf0fc9e81'
AND (
token = 'nG8p2zjAzhkcO943BJ/XjALjQZouuV2t9BrTRgamHuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)