UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNaaNY/h2W+Z3oDAjzTGrCc8Jl6z+D/RhX12XoaG6rI='
WHERE
key_id = '9efc0b5f9217d9fd2b77755a2049026d928d5cc363eb335697884340f0398ef2'
AND (
token = 'gNaaNY/h2W+Z3oDAjzTGrCc8Jl6z+D/RhX12XoaG6rI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)