UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hqKRbnWWj4pvARxznLAqhEXwrX4X6BMXTM5FVuFrx8s='
WHERE
key_id = 'fc5eaedcc1c8d2ffff6f4e5be4696b185da1a5c788fde4f31560ad15f3fd4fc7'
AND (
token = 'hqKRbnWWj4pvARxznLAqhEXwrX4X6BMXTM5FVuFrx8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)