UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9gL/VCth0tHONbw1Wo3OVuDpVC+yGA5CQSr8RY9Wk80='
WHERE
key_id = 'dfe5f8173a40ee504d0e8ffe1f9094a36e9b89c85df56a9bbde4a5bcf384984f'
AND (
token = '9gL/VCth0tHONbw1Wo3OVuDpVC+yGA5CQSr8RY9Wk80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)