UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xlg3j0B5XfLfNAdRT/giqytlQx4h04TdY0lnwsPu0y4='
WHERE
key_id = 'de89c8b408708103158c6bc74ad86e4c898fa1f4b811e4dbe00bf444d90c485a'
AND (
token = 'Xlg3j0B5XfLfNAdRT/giqytlQx4h04TdY0lnwsPu0y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)