UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P2x54AZQnzFPcHyRgfXS7lproEfzOgnW+XXDh7rL+nA='
WHERE
key_id = 'd7e1817a30dc9a343918b29d993c5abeb520d9cb6f4d7fdefccb6c03fff77650'
AND (
token = 'P2x54AZQnzFPcHyRgfXS7lproEfzOgnW+XXDh7rL+nA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)