UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1SgppPFyXj06qMG5UGejDqQJ6cNbHO5/wacQ3LZff5o='
WHERE
key_id = '50e275ba4c89a2d49504387761d6a3cc464c02daca101a60ca70ec0de3ce1687'
AND (
token = '1SgppPFyXj06qMG5UGejDqQJ6cNbHO5/wacQ3LZff5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)