UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hPCU28puW5hI2QrWF8BXKE6fcztMRbW6KawppAnyhKk='
WHERE
key_id = '4e065053685a097d0b2b6345a6d58f5a5fd0cad06b5abb600bd619fcf2cd5d3b'
AND (
token = 'hPCU28puW5hI2QrWF8BXKE6fcztMRbW6KawppAnyhKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)