UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVPAmo9zpQInefHatipx2KclbUHgL4+vjG3YnN/gfgI='
WHERE
key_id = '40f719d2515bfe7371947f256a63aa01f83a5e516cec693cbe60dbbfe53d83df'
AND (
token = 'pVPAmo9zpQInefHatipx2KclbUHgL4+vjG3YnN/gfgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)