UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/mG8EnK7n7zrU4WRpif0wZtJjtJWI80s/8QfdQvH7vQ='
WHERE
key_id = '43916d9a4487d3248157b18b7087c91f68c1fec4a1a705bcea70513de18b0b0a'
AND (
token = '/mG8EnK7n7zrU4WRpif0wZtJjtJWI80s/8QfdQvH7vQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)