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