UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nW1Kr8NiYDgno4yUwQZQVtcLTQ/rtMAk7SzcA+rTSoY='
WHERE
key_id = 'e4b6ba2f4fc921b4ff2dc36c7f92197a5f5d1d6d47aad7c7866304cdf3c3e988'
AND (
token = 'nW1Kr8NiYDgno4yUwQZQVtcLTQ/rtMAk7SzcA+rTSoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)