UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4vkE4KvNOViOMXe1mS8vS0N2kiOSoTVKgCjGZNE0tI4='
WHERE
key_id = '6a1bc4352771614c8c3229d49dcda1f234b51ec048cfe6631f09a136e4e993c4'
AND (
token = '4vkE4KvNOViOMXe1mS8vS0N2kiOSoTVKgCjGZNE0tI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)