UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEoyPx84OLhXgqkuK2gpYBukVA4MCufmvJlb7AdYuHk='
WHERE
key_id = '7a1d8a326d191d16257900f30f48da2930cd71b98dc65c85b6155766ea7f0a10'
AND (
token = 'XEoyPx84OLhXgqkuK2gpYBukVA4MCufmvJlb7AdYuHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)