UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHVRpAc4Oi9vOu/LLRb5COYjJkbk5BghpkCKksZsuWA='
WHERE
key_id = '230e33a137a23c1992867ffb5d6714c5b5af2f1a99434c4930102827ca2d2cb7'
AND (
token = 'zHVRpAc4Oi9vOu/LLRb5COYjJkbk5BghpkCKksZsuWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)