UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TTXab06YWdsPCL24e4kAzA90ndXrJxG+gzDYwEWak7w='
WHERE
key_id = '470d5164c422196567c54ff19e9595a96b3d06b9c55f7e72669874d5cc3f9247'
AND (
token = 'TTXab06YWdsPCL24e4kAzA90ndXrJxG+gzDYwEWak7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)