UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '540CSFc1DIx7NTXNaHt5VV/2T7mtZYF3ogcire5tgJA='
WHERE
key_id = '51867e34525a5852b0945b19ce7837192525bd92cf54b98ac1e39105a2e669a3'
AND (
token = '540CSFc1DIx7NTXNaHt5VV/2T7mtZYF3ogcire5tgJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)